Create new Model


Create a new table model


Step 1

                   - Copy pest the Main table 3 times

                   -  Rename the first table Zika-Confirmed

                   - Rename the Second t table Zika-Deaths

                   - Rename the third table Zika-Suspected

Step 2

 Create Zika-Confirmed table

                       -        Filter the FDF by Confirmed Only

-        Select FDF, Country/territory, Data Publication date and case columns (By Using hold ctrl and click the columns)

-        Click Remove Column and Select Remove Other Columns

-        Rename The case Column by Confirmed

-        Remove FDF column

Step 3

 Create Zika-Death table

                       -        Filter the FDF by Deaths Only

-        Select FDF, Country/territory, Data Publication date and case columns (By Using hold ctrl and click the columns)

-        Click Remove Column and Select Remove Other Columns

-        Rename The case Column by Deaths

-        Remove FDF column

 

Step 4

   Create Zika-Suspected table 

-        Filter the FDF by Suspected Only

-        Select FDF, Country/territory, Data Publication date and case columns (By Using hold ctrl and click the columns)

-        Click Remove Column and Select Remove Other Columns

-        Rename The case Column by Suspected

-        Remove FDF column 




Create a Date table 

Steps

-       Click on Modeling

-       Select New Table

-       Put below DAX code


   Date = ADDCOLUMNS (

CALENDAR (Min('Zika-cases'[Data Publication Date]), MAX('Zika-cases'[Data Publication Date])),

"Dates", FORMAT ( [Date], "MM/DD/YYYY" ),

"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),

"Year", YEAR ( [Date] ),

"Monthnumber", FORMAT ( [Date], "MM" ),

"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),

"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),

"MonthNameShort", FORMAT ( [Date], "mmm" ),

"Month", FORMAT ( [Date], "mmmm" ),

"DayOfWeekNumber", WEEKDAY ( [Date] ),

"DayOfWeek", FORMAT ( [Date], "dddd" ),

"DayOfWeekShort", FORMAT ( [Date], "ddd" ),

"Quarter", "Q" & FORMAT ( [Date], "Q" ),

"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )

)




 

 Make Relationship

 

below like help to see how we build a data model

https://www.youtube.com/watch?v=dmSDvWyLl2E